How to EXTRACT from long string by SQL BigQuery

join shbcf.ru